Data Import-Actual Costs
Cobra is very flexible in terms of loading actual costs. You can select the level at which they are captured.
If actual costs are loaded from an import file, you select the charge number identifier, whether or not the file is cumulative-to-date, and so on.
Cobra offers a wide variety of options related to the entry of actual costs for a project.
- You can enter actual costs either at the control account or work package level.
- The actual costs can link to one or many of the control account fields, or the work package field, or any code assignment.
- You can import actual costs into a master project and the values are posted to the subproject.
- Files can contain either cumulative or current period costs.
The succeeding topics contain information about creating an actual cost import file, entering actual costs using both import files and manual procedures, and using the Integration wizard to import actual costs.
- Related Topics:
- Control Account Versus Work Package Level
When you create a project, Cobra allows you to indicate whether you want to enter actual costs at the control account or the work package level. Cobra then defines the default actual cost class (AC) and forecast cost class (F1) to function at the appropriate level. - Cumulative versus Current Period Costs
You can enter actual costs either for the current period or as a cumulative-to-date figure. In either case, the system stores the current period value; if you enter cumulative values, Cobra subtracts the previous cumulative value to arrive at the correct current period value. - Master Project Versus Individual Projects
You may extract a single actual cost import file from your accounting system and load that file into a master project instead of creating a different actual cost import file for each project. - Control Account Fields Versus Codes
When actual costs are posted to a project, a unique identifier must be used to process the import file. - First Result and Derived Costs
You can enter actual costs in terms of first result and have Cobra calculate the derived costs, or you can enter each result individually. - Cost Classes
If you have defined custom cost classes for actual costs, you can display and enter costs using any actual cost class. - Entering Actual Costs
Under normal circumstances, you enter information about actual costs after updating all schedule status information. By default, Cobra allows the entry of actual cost information only for open work items. - Loading Actual Cost Records
Using the Integration Wizard, you can import actual cost records either from a CSV file or from a database table. - Create an MS SQL Database Connection to Load Actual Costs
Use this procedure to create a connection to an MS SQL database in order to load actual costs during integration. - Import Actual Cost Data
Use the Integration Wizard to import actual cost data. - Integration Wizard-Actual Costs
To import actual costs, you must complete the information required on each page of the Integration Wizard.
Parent Topic: Integration Wizard